
/*this sas files extracts data from all monthly CPS filesfor January 2003 through
December 2009.  All files are stacked in the single data set combined0309.sas7dbat*/

/*change the directory to whereve you stored these data sets.  We are not including 
the CPS data sets in our archive.  These files are publicly available from the BLS at 
http://thedataweb.rm.census.gov/ftp/cps_ftp.html*/

libname everify 'H:\research\state immigration laws\cpsfiles';
options nocenter;
options linesize=78;


 



/*2003*/

data Jan03;
infile 'H:\research\state immigration laws\cpsfiles\Jan03pub.cps' lrecl=875;
input month 16-17 year 18-21 hetenure 29-30 hweight 47-56 .4
gestfips 93-94 rref 118-119 age 122-123
sex 129-130 educ 137-138 race 139-140 hispanic  157-158
marital 159-160 type 161-162 
country 163-165 citizen 172-173 employment 180-181 peio1cow 432-433 prdtind1 472-473  enroled 575-576
weight 613-622 .4 qstnum 815-819 occurnum 820-821;
run;
proc means;
run;

data feb03;
infile 'H:\research\state immigration laws\cpsfiles\feb03pub.cps' lrecl=875;
input month 16-17 year 18-21 hetenure 29-30 hweight 47-56 .4
gestfips 93-94 rref 118-119 age 122-123
sex 129-130 educ 137-138 race 139-140 hispanic  157-158
marital 159-160 type 161-162 
country 163-165 citizen 172-173 employment 180-181 peio1cow 432-433 prdtind1 472-473  enroled 575-576
weight 613-622 .4 qstnum 815-819 occurnum 820-821;
run;
proc means;
run;

data mar03;
infile 'H:\research\state immigration laws\cpsfiles\mar03pub.cps' lrecl=875;
input month 16-17 year 18-21 hetenure 29-30 hweight 47-56 .4
gestfips 93-94 rref 118-119 age 122-123
sex 129-130 educ 137-138 race 139-140 hispanic  157-158
marital 159-160 type 161-162 
country 163-165 citizen 172-173 employment 180-181 peio1cow 432-433 prdtind1 472-473  enroled 575-576
weight 613-622 .4 qstnum 815-819 occurnum 820-821;
run;
proc means;
run;

data apr03;
infile 'H:\research\state immigration laws\cpsfiles\apr03pub.cps' lrecl=875;
input month 16-17 year 18-21 hetenure 29-30 hweight 47-56 .4
gestfips 93-94 rref 118-119 age 122-123
sex 129-130 educ 137-138 race 139-140 hispanic  157-158
marital 159-160 type 161-162 
country 163-165 citizen 172-173 employment 180-181 peio1cow 432-433 prdtind1 472-473  enroled 575-576
weight 613-622 .4 qstnum 815-819 occurnum 820-821;
run;
proc means;
run;

data may03;
infile 'H:\research\state immigration laws\cpsfiles\may03pub.cps' lrecl=875;
input month 16-17 year 18-21 hetenure 29-30 hweight 47-56 .4
gestfips 93-94 rref 118-119 age 122-123
sex 129-130 educ 137-138 race 139-140 hispanic  157-158
marital 159-160 type 161-162 
country 163-165 citizen 172-173 employment 180-181 peio1cow 432-433 prdtind1 472-473  enroled 575-576
weight 613-622 .4 qstnum 815-819 occurnum 820-821;
run;
proc means;
run;
data jun03;
infile 'H:\research\state immigration laws\cpsfiles\jun03pub.cps' lrecl=875;
input month 16-17 year 18-21 hetenure 29-30 hweight 47-56 .4
gestfips 93-94 rref 118-119 age 122-123
sex 129-130 educ 137-138 race 139-140 hispanic  157-158
marital 159-160 type 161-162 
country 163-165 citizen 172-173 employment 180-181 peio1cow 432-433 prdtind1 472-473  enroled 575-576
weight 613-622 .4 qstnum 815-819 occurnum 820-821;
run;
proc means;
run;
data jul03;
infile 'H:\research\state immigration laws\cpsfiles\jul03pub.cps' lrecl=875;
input month 16-17 year 18-21 hetenure 29-30 hweight 47-56 .4
gestfips 93-94 rref 118-119 age 122-123
sex 129-130 educ 137-138 race 139-140 hispanic  157-158
marital 159-160 type 161-162 
country 163-165 citizen 172-173 employment 180-181 peio1cow 432-433 prdtind1 472-473  enroled 575-576
weight 613-622 .4 qstnum 815-819 occurnum 820-821;
run;
proc means;
run;
data aug03;
infile 'H:\research\state immigration laws\cpsfiles\aug03pub.cps' lrecl=875;
input month 16-17 year 18-21 hetenure 29-30 hweight 47-56 .4
gestfips 93-94 rref 118-119 age 122-123
sex 129-130 educ 137-138 race 139-140 hispanic  157-158
marital 159-160 type 161-162 
country 163-165 citizen 172-173 employment 180-181 peio1cow 432-433 prdtind1 472-473  enroled 575-576
weight 613-622 .4 qstnum 815-819 occurnum 820-821;
run;
proc means;
run;
data sep03;
infile 'H:\research\state immigration laws\cpsfiles\sep03pub.cps' lrecl=875;
input month 16-17 year 18-21 hetenure 29-30 hweight 47-56 .4
gestfips 93-94 rref 118-119 age 122-123
sex 129-130 educ 137-138 race 139-140 hispanic  157-158
marital 159-160 type 161-162 
country 163-165 citizen 172-173 employment 180-181 peio1cow 432-433 prdtind1 472-473  enroled 575-576
weight 613-622 .4 qstnum 815-819 occurnum 820-821;
run;
proc means;
run;
data oct03;
infile 'H:\research\state immigration laws\cpsfiles\oct03pub.cps' lrecl=875;
input month 16-17 year 18-21 hetenure 29-30 hweight 47-56 .4
gestfips 93-94 rref 118-119 age 122-123
sex 129-130 educ 137-138 race 139-140 hispanic  157-158
marital 159-160 type 161-162 
country 163-165 citizen 172-173 employment 180-181 peio1cow 432-433 prdtind1 472-473  enroled 575-576
weight 613-622 .4 qstnum 815-819 occurnum 820-821;
run; 
proc means;
run;
data nov03;
infile 'H:\research\state immigration laws\cpsfiles\nov03pub.cps' lrecl=875;
input month 16-17 year 18-21 hetenure 29-30 hweight 47-56 .4
gestfips 93-94 rref 118-119 age 122-123
sex 129-130 educ 137-138 race 139-140 hispanic  157-158
marital 159-160 type 161-162 
country 163-165 citizen 172-173 employment 180-181 peio1cow 432-433 prdtind1 472-473  enroled 575-576
weight 613-622 .4 qstnum 815-819 occurnum 820-821;
run;
proc means;
run;
data dec03;
infile 'H:\research\state immigration laws\cpsfiles\dec03pub.cps' lrecl=875;
input month 16-17 year 18-21 hetenure 29-30 hweight 47-56 .4
gestfips 93-94 rref 118-119 age 122-123
sex 129-130 educ 137-138 race 139-140 hispanic  157-158
marital 159-160 type 161-162 
country 163-165 citizen 172-173 employment 180-181 peio1cow 432-433 prdtind1 472-473  enroled 575-576
weight 613-622 .4 qstnum 815-819 occurnum 820-821;
run;
proc means;
run;
 



/*2004*/

data Jan04;
infile 'H:\research\state immigration laws\cpsfiles\Jan04pub.cps' lrecl=875;
input month 16-17 year 18-21 hetenure 29-30 hweight 47-56 .4
gestfips 93-94 rref 118-119 age 122-123
sex 129-130 educ 137-138 race 139-140 hispanic  157-158
marital 159-160 type 161-162 
country 163-165 citizen 172-173 employment 180-181 peio1cow 432-433 prdtind1 472-473  enroled 575-576
weight 613-622 .4 qstnum 815-819 occurnum 820-821;
run;
proc means;
run;

data feb04;
infile 'H:\research\state immigration laws\cpsfiles\feb04pub.cps' lrecl=875;
input month 16-17 year 18-21 hetenure 29-30 hweight 47-56 .4
gestfips 93-94 rref 118-119 age 122-123
sex 129-130 educ 137-138 race 139-140 hispanic  157-158
marital 159-160 type 161-162 
country 163-165 citizen 172-173 employment 180-181 peio1cow 432-433 prdtind1 472-473  enroled 575-576
weight 613-622 .4 qstnum 815-819 occurnum 820-821;
run;
proc means;
run;

data mar04;
infile 'H:\research\state immigration laws\cpsfiles\mar04pub.cps' lrecl=875;
input month 16-17 year 18-21 hetenure 29-30 hweight 47-56 .4
gestfips 93-94 rref 118-119 age 122-123
sex 129-130 educ 137-138 race 139-140 hispanic  157-158
marital 159-160 type 161-162 
country 163-165 citizen 172-173 employment 180-181 peio1cow 432-433 prdtind1 472-473  enroled 575-576
weight 613-622 .4 qstnum 815-819 occurnum 820-821;
run;
proc means;
run;

data apr04;
infile 'H:\research\state immigration laws\cpsfiles\apr04pub.cps' lrecl=875;
input month 16-17 year 18-21 hetenure 29-30 hweight 47-56 .4
gestfips 93-94 rref 118-119 age 122-123
sex 129-130 educ 137-138 race 139-140 hispanic  157-158
marital 159-160 type 161-162 
country 163-165 citizen 172-173 employment 180-181 peio1cow 432-433 prdtind1 472-473  enroled 575-576
weight 613-622 .4 qstnum 815-819 occurnum 820-821;
run;
proc means;
run;

data may04;
infile 'H:\research\state immigration laws\cpsfiles\may04pub.cps' lrecl=900;
input month 16-17 year 18-21 hetenure 29-30 hweight 47-56 .4
gestfips 93-94 rref 118-119 age 122-123
sex 129-130 educ 137-138 race 139-140 hispanic  157-158
marital 159-160 type 161-162 
country 163-165 citizen 172-173 employment 180-181 peio1cow 432-433 prdtind1 472-473  enroled 575-576
weight 613-622 .4 qstnum 815-819 occurnum 820-821;
run;
proc means;
run;
data jun04;
infile 'H:\research\state immigration laws\cpsfiles\jun04pub.cps' lrecl=900;
input month 16-17 year 18-21 hetenure 29-30 hweight 47-56 .4
gestfips 93-94 rref 118-119 age 122-123
sex 129-130 educ 137-138 race 139-140 hispanic  157-158
marital 159-160 type 161-162 
country 163-165 citizen 172-173 employment 180-181 peio1cow 432-433 prdtind1 472-473  enroled 575-576
weight 613-622 .4 qstnum 815-819 occurnum 820-821;
run;
proc means;
run;
data jul04;
infile 'H:\research\state immigration laws\cpsfiles\jul04pub.cps' lrecl=900;
input month 16-17 year 18-21 hetenure 29-30 hweight 47-56 .4
gestfips 93-94 rref 118-119 age 122-123
sex 129-130 educ 137-138 race 139-140 hispanic  157-158
marital 159-160 type 161-162 
country 163-165 citizen 172-173 employment 180-181 peio1cow 432-433 prdtind1 472-473  enroled 575-576
weight 613-622 .4 qstnum 815-819 occurnum 820-821;
run;
proc means;
run;
data aug04;
infile 'H:\research\state immigration laws\cpsfiles\aug04pub.cps' lrecl=900;
input month 16-17 year 18-21 hetenure 29-30 hweight 47-56 .4
gestfips 93-94 rref 118-119 age 122-123
sex 129-130 educ 137-138 race 139-140 hispanic  157-158
marital 159-160 type 161-162 
country 163-165 citizen 172-173 employment 180-181 peio1cow 432-433 prdtind1 472-473  enroled 575-576
weight 613-622 .4 qstnum 815-819 occurnum 820-821;
run;
proc means;
run;
data sep04;
infile 'H:\research\state immigration laws\cpsfiles\sep04pub.cps' lrecl=900;
input month 16-17 year 18-21 hetenure 29-30 hweight 47-56 .4
gestfips 93-94 rref 118-119 age 122-123
sex 129-130 educ 137-138 race 139-140 hispanic  157-158
marital 159-160 type 161-162 
country 163-165 citizen 172-173 employment 180-181 peio1cow 432-433 prdtind1 472-473  enroled 575-576
weight 613-622 .4 qstnum 815-819 occurnum 820-821;
run;
proc means;
run;
data oct04;
infile 'H:\research\state immigration laws\cpsfiles\oct04pub.cps' lrecl=900;
input month 16-17 year 18-21 hetenure 29-30 hweight 47-56 .4
gestfips 93-94 rref 118-119 age 122-123
sex 129-130 educ 137-138 race 139-140 hispanic  157-158
marital 159-160 type 161-162 
country 163-165 citizen 172-173 employment 180-181 peio1cow 432-433 prdtind1 472-473  enroled 575-576
weight 613-622 .4 qstnum 815-819 occurnum 820-821;
run; 
proc means;
run;
data nov04;
infile 'H:\research\state immigration laws\cpsfiles\nov04pub.cps' lrecl=900;
input month 16-17 year 18-21 hetenure 29-30 hweight 47-56 .4
gestfips 93-94 rref 118-119 age 122-123
sex 129-130 educ 137-138 race 139-140 hispanic  157-158
marital 159-160 type 161-162 
country 163-165 citizen 172-173 employment 180-181 peio1cow 432-433 prdtind1 472-473  enroled 575-576
weight 613-622 .4 qstnum 815-819 occurnum 820-821;
run;
proc means;
run;
data dec04;
infile 'H:\research\state immigration laws\cpsfiles\dec04pub.cps' lrecl=900;
input month 16-17 year 18-21 hetenure 29-30 hweight 47-56 .4
gestfips 93-94 rref 118-119 age 122-123
sex 129-130 educ 137-138 race 139-140 hispanic  157-158
marital 159-160 type 161-162 
country 163-165 citizen 172-173 employment 180-181 peio1cow 432-433 prdtind1 472-473  enroled 575-576
weight 613-622 .4 qstnum 815-819 occurnum 820-821;
run;
proc means;
run;
 

/*2005*/


data jan05;
infile 'H:\research\state immigration laws\cpsfiles\jan05pub.cps' lrecl=900;
input month 16-17 year 18-21 hetenure 29-30 hweight 47-56 .4
gestfips 93-94 rref 118-119 age 122-123
sex 129-130 educ 137-138 race 139-140 hispanic  157-158
marital 159-160 type 161-162 
country 163-165 citizen 172-173 employment 180-181 peio1cow 432-433 prdtind1 472-473  enroled 575-576
weight 613-622 .4 qstnum 815-819 occurnum 820-821;
run;
proc means;
run;


data feb05;
infile 'H:\research\state immigration laws\cpsfiles\feb05pub.cps' lrecl=900;
input month 16-17 year 18-21 hetenure 29-30 hweight 47-56 .4
gestfips 93-94 rref 118-119 age 122-123
sex 129-130 educ 137-138 race 139-140 hispanic  157-158
marital 159-160 type 161-162 
country 163-165 citizen 172-173 employment 180-181 peio1cow 432-433 prdtind1 472-473  enroled 575-576
weight 613-622 .4 qstnum 815-819 occurnum 820-821;


run;
proc means;
run;

data mar05;
infile 'H:\research\state immigration laws\cpsfiles\mar05pub.cps' lrecl=900;
input month 16-17 year 18-21 hetenure 29-30 hweight 47-56 .4
gestfips 93-94 rref 118-119 age 122-123
sex 129-130 educ 137-138 race 139-140 hispanic  157-158
marital 159-160 type 161-162 
country 163-165 citizen 172-173 employment 180-181 peio1cow 432-433 prdtind1 472-473  enroled 575-576
weight 613-622 .4 qstnum 815-819 occurnum 820-821;


run;
proc means;
run;

data apr05;
infile 'H:\research\state immigration laws\cpsfiles\apr05pub.cps' lrecl=900;
input month 16-17 year 18-21 hetenure 29-30 hweight 47-56 .4
gestfips 93-94 rref 118-119 age 122-123
sex 129-130 educ 137-138 race 139-140 hispanic  157-158
marital 159-160 type 161-162 
country 163-165 citizen 172-173 employment 180-181 peio1cow 432-433 prdtind1 472-473  enroled 575-576
weight 613-622 .4 qstnum 815-819 occurnum 820-821;


run;
proc means;
run;

data may05;
infile 'H:\research\state immigration laws\cpsfiles\may05pub.cps' lrecl=900;
input month 16-17 year 18-21 hetenure 29-30 hweight 47-56 .4
gestfips 93-94 rref 118-119 age 122-123
sex 129-130 educ 137-138 race 139-140 hispanic  157-158
marital 159-160 type 161-162 
country 163-165 citizen 172-173 employment 180-181 peio1cow 432-433 prdtind1 472-473  enroled 575-576
weight 613-622 .4 qstnum 815-819 occurnum 820-821;


run;
proc means;
run;


data jun05;
infile 'H:\research\state immigration laws\cpsfiles\jun05pub.cps' lrecl=900;
input month 16-17 year 18-21 hetenure 29-30 hweight 47-56 .4
gestfips 93-94 rref 118-119 age 122-123
sex 129-130 educ 137-138 race 139-140 hispanic  157-158
marital 159-160 type 161-162 
country 163-165 citizen 172-173 employment 180-181 peio1cow 432-433 prdtind1 472-473  enroled 575-576
weight 613-622 .4 qstnum 815-819 occurnum 820-821;


run;
proc means;
run;


data jul05;
infile 'H:\research\state immigration laws\cpsfiles\jul05pub.cps' lrecl=900;
input month 16-17 year 18-21 hetenure 29-30 hweight 47-56 .4
gestfips 93-94 rref 118-119 age 122-123
sex 129-130 educ 137-138 race 139-140 hispanic  157-158
marital 159-160 type 161-162 
country 163-165 citizen 172-173 employment 180-181 peio1cow 432-433 prdtind1 472-473  enroled 575-576
weight 613-622 .4 qstnum 815-819 occurnum 820-821;


run;
proc means;
run;

data aug05;
infile 'H:\research\state immigration laws\cpsfiles\aug05pub.cps' lrecl=900;
input month 16-17 year 18-21 hetenure 29-30 hweight 47-56 .4
gestfips 93-94 rref 118-119 age 122-123
sex 129-130 educ 137-138 race 139-140 hispanic  157-158
marital 159-160 type 161-162 
country 163-165 citizen 172-173 employment 180-181 peio1cow 432-433 prdtind1 472-473  enroled 575-576
weight 613-622 .4 qstnum 815-819 occurnum 820-821;


run;
proc means;
run;

data sep05;
infile 'H:\research\state immigration laws\cpsfiles\sep05pub.cps' lrecl=900;
input month 16-17 year 18-21 hetenure 29-30 hweight 47-56 .4
gestfips 93-94 rref 118-119 age 122-123
sex 129-130 educ 137-138 race 139-140 hispanic  157-158
marital 159-160 type 161-162 
country 163-165 citizen 172-173 employment 180-181 peio1cow 432-433 prdtind1 472-473  enroled 575-576
weight 613-622 .4 qstnum 815-819 occurnum 820-821;


run;
proc means;
run;

data oct05;
infile 'H:\research\state immigration laws\cpsfiles\oct05pub.cps' lrecl=900;
input month 16-17 year 18-21 hetenure 29-30 hweight 47-56 .4
gestfips 93-94 rref 118-119 age 122-123
sex 129-130 educ 137-138 race 139-140 hispanic  157-158
marital 159-160 type 161-162 
country 163-165 citizen 172-173 employment 180-181 peio1cow 432-433 prdtind1 472-473  enroled 575-576
weight 613-622 .4 qstnum 815-819 occurnum 820-821;


run;
proc means;
run;


data nov05;
infile 'H:\research\state immigration laws\cpsfiles\nov05pub.cps' lrecl=900;
input month 16-17 year 18-21 hetenure 29-30 hweight 47-56 .4
gestfips 93-94 rref 118-119 age 122-123
sex 129-130 educ 137-138 race 139-140 hispanic  157-158
marital 159-160 type 161-162 
country 163-165 citizen 172-173 employment 180-181 peio1cow 432-433 prdtind1 472-473  enroled 575-576
weight 613-622 .4 qstnum 815-819 occurnum 820-821;


run;
proc means;
run;

data dec05;
infile 'H:\research\state immigration laws\cpsfiles\dec05pub.cps' lrecl=900;
input month 16-17 year 18-21 hetenure 29-30 hweight 47-56 .4
gestfips 93-94 rref 118-119 age 122-123
sex 129-130 educ 137-138 race 139-140 hispanic  157-158
marital 159-160 type 161-162 
country 163-165 citizen 172-173 employment 180-181 peio1cow 432-433 prdtind1 472-473  enroled 575-576
weight 613-622 .4 qstnum 815-819 occurnum 820-821;


run;
proc sort;
by qstnum occurnum;
run;

proc means;
run;

 
/****2006***/


data jan06;
infile 'H:\research\state immigration laws\cpsfiles\jan06pub.cps' lrecl=900;
input month 16-17 year 18-21 hetenure 29-30 hweight 47-56 .4
gestfips 93-94 rref 118-119 age 122-123
sex 129-130 educ 137-138 race 139-140 hispanic  157-158
marital 159-160 type 161-162 
country 163-165 citizen 172-173 employment 180-181 peio1cow 432-433 prdtind1 472-473  enroled 575-576
weight 613-622 .4 qstnum 815-819 occurnum 820-821;


run;
proc means;
run;


data feb06;
infile 'H:\research\state immigration laws\cpsfiles\feb06pub.cps' lrecl=900;
input month 16-17 year 18-21 hetenure 29-30 hweight 47-56 .4
gestfips 93-94 rref 118-119 age 122-123
sex 129-130 educ 137-138 race 139-140 hispanic  157-158
marital 159-160 type 161-162 
country 163-165 citizen 172-173 employment 180-181 peio1cow 432-433 prdtind1 472-473  enroled 575-576
weight 613-622 .4 qstnum 815-819 occurnum 820-821;


run;
proc means;
run;

data mar06;
infile 'H:\research\state immigration laws\cpsfiles\mar06pub.dat' lrecl=900;
input month 16-17 year 18-21 hetenure 29-30 hweight 47-56 .4
gestfips 93-94 rref 118-119 age 122-123
sex 129-130 educ 137-138 race 139-140 hispanic  157-158
marital 159-160 type 161-162 
country 163-165 citizen 172-173 employment 180-181 peio1cow 432-433 prdtind1 472-473  enroled 575-576
weight 613-622 .4 qstnum 815-819 occurnum 820-821;


run;
proc means;
run;

data apr06;
infile 'H:\research\state immigration laws\cpsfiles\apr06pub.dat' lrecl=900;
input month 16-17 year 18-21 hetenure 29-30 hweight 47-56 .4
gestfips 93-94 rref 118-119 age 122-123
sex 129-130 educ 137-138 race 139-140 hispanic  157-158
marital 159-160 type 161-162 
country 163-165 citizen 172-173 employment 180-181 peio1cow 432-433 prdtind1 472-473  enroled 575-576
weight 613-622 .4 qstnum 815-819 occurnum 820-821;


run;
proc means;
run;

data may06;
infile 'H:\research\state immigration laws\cpsfiles\may06pub.dat' lrecl=900;
input month 16-17 year 18-21 hetenure 29-30 hweight 47-56 .4
gestfips 93-94 rref 118-119 age 122-123
sex 129-130 educ 137-138 race 139-140 hispanic  157-158
marital 159-160 type 161-162 
country 163-165 citizen 172-173 employment 180-181 peio1cow 432-433 prdtind1 472-473  enroled 575-576
weight 613-622 .4 qstnum 815-819 occurnum 820-821;


run;
proc means;
run;


data jun06;
infile 'H:\research\state immigration laws\cpsfiles\jun06pub.dat' lrecl=900;
input month 16-17 year 18-21 hetenure 29-30 hweight 47-56 .4
gestfips 93-94 rref 118-119 age 122-123
sex 129-130 educ 137-138 race 139-140 hispanic  157-158
marital 159-160 type 161-162 
country 163-165 citizen 172-173 employment 180-181 peio1cow 432-433 prdtind1 472-473  enroled 575-576
weight 613-622 .4 qstnum 815-819 occurnum 820-821;


run;
proc means;
run;


data jul06;
infile 'H:\research\state immigration laws\cpsfiles\jul06pub.dat' lrecl=900;
input month 16-17 year 18-21 hetenure 29-30 hweight 47-56 .4
gestfips 93-94 rref 118-119 age 122-123
sex 129-130 educ 137-138 race 139-140 hispanic  157-158
marital 159-160 type 161-162 
country 163-165 citizen 172-173 employment 180-181 peio1cow 432-433 prdtind1 472-473  enroled 575-576
weight 613-622 .4 qstnum 815-819 occurnum 820-821;


run;
proc means;
run;


data aug06;
infile 'H:\research\state immigration laws\cpsfiles\aug06pub.dat' lrecl=900;
input month 16-17 year 18-21 hetenure 29-30 hweight 47-56 .4
gestfips 93-94 rref 118-119 age 122-123
sex 129-130 educ 137-138 race 139-140 hispanic  157-158
marital 159-160 type 161-162 
country 163-165 citizen 172-173 employment 180-181 peio1cow 432-433 prdtind1 472-473  enroled 575-576
weight 613-622 .4 qstnum 815-819 occurnum 820-821;


run;
proc means;
run;

data sep06;
infile 'H:\research\state immigration laws\cpsfiles\sep06pub.dat' lrecl=900;
input month 16-17 year 18-21 hetenure 29-30 hweight 47-56 .4
gestfips 93-94 rref 118-119 age 122-123
sex 129-130 educ 137-138 race 139-140 hispanic  157-158
marital 159-160 type 161-162 
country 163-165 citizen 172-173 employment 180-181 peio1cow 432-433 prdtind1 472-473  enroled 575-576
weight 613-622 .4 qstnum 815-819 occurnum 820-821;


run;
proc means;
run;

data oct06;
infile 'H:\research\state immigration laws\cpsfiles\oct06pub.dat' lrecl=900;
input month 16-17 year 18-21 hetenure 29-30 hweight 47-56 .4
gestfips 93-94 rref 118-119 age 122-123
sex 129-130 educ 137-138 race 139-140 hispanic  157-158
marital 159-160 type 161-162 
country 163-165 citizen 172-173 employment 180-181 peio1cow 432-433 prdtind1 472-473  enroled 575-576
weight 613-622 .4 qstnum 815-819 occurnum 820-821;


run;
proc means;
run;


data nov06;
infile 'H:\research\state immigration laws\cpsfiles\nov06pub.dat' lrecl=900;
input month 16-17 year 18-21 hetenure 29-30 hweight 47-56 .4
gestfips 93-94 rref 118-119 age 122-123
sex 129-130 educ 137-138 race 139-140 hispanic  157-158
marital 159-160 type 161-162 
country 163-165 citizen 172-173 employment 180-181 peio1cow 432-433 prdtind1 472-473  enroled 575-576
weight 613-622 .4 qstnum 815-819 occurnum 820-821;


run;
proc means;
run;

data dec06;
infile 'H:\research\state immigration laws\cpsfiles\dec06pub.dat' lrecl=900;
input month 16-17 year 18-21 hetenure 29-30 hweight 47-56 .4
gestfips 93-94 rref 118-119 age 122-123
sex 129-130 educ 137-138 race 139-140 hispanic  157-158
marital 159-160 type 161-162 
country 163-165 citizen 172-173 employment 180-181 peio1cow 432-433 prdtind1 472-473  enroled 575-576
weight 613-622 .4 qstnum 815-819 occurnum 820-821;


run;
proc means;
run;
data jan07;
infile 'H:\research\state immigration laws\cpsfiles\jan07pub.dat' lrecl=950;
input month 16-17 year 18-21 hetenure 29-30 hweight 47-56 .4
gestfips 93-94 rref 118-119 age 122-123
sex 129-130 educ 137-138 race 139-140 hispanic  157-158
marital 159-160 type 161-162 
country 163-165 citizen 172-173 employment 180-181 peio1cow 432-433 prdtind1 472-473  enroled 575-576
weight 613-622 .4 qstnum 815-819 occurnum 820-821;


run;
proc means;
run;


data feb07;
infile 'H:\research\state immigration laws\cpsfiles\feb07pub.dat' lrecl=950;
input month 16-17 year 18-21 hetenure 29-30 hweight 47-56 .4
gestfips 93-94 rref 118-119 age 122-123
sex 129-130 educ 137-138 race 139-140 hispanic  157-158
marital 159-160 type 161-162 
country 163-165 citizen 172-173 employment 180-181 peio1cow 432-433 prdtind1 472-473  enroled 575-576
weight 613-622 .4 qstnum 815-819 occurnum 820-821;


run;
proc means;
run;

data mar07;
infile 'H:\research\state immigration laws\cpsfiles\mar07pub.dat' lrecl=950;
input month 16-17 year 18-21 hetenure 29-30 hweight 47-56 .4
gestfips 93-94 rref 118-119 age 122-123
sex 129-130 educ 137-138 race 139-140 hispanic  157-158
marital 159-160 type 161-162 
country 163-165 citizen 172-173 employment 180-181 peio1cow 432-433 prdtind1 472-473  enroled 575-576
weight 613-622 .4 qstnum 815-819 occurnum 820-821;


run;
proc means;
run;

data apr07;
infile 'H:\research\state immigration laws\cpsfiles\apr07pub.dat' lrecl=950;
input month 16-17 year 18-21 hetenure 29-30 hweight 47-56 .4
gestfips 93-94 rref 118-119 age 122-123
sex 129-130 educ 137-138 race 139-140 hispanic  157-158
marital 159-160 type 161-162 
country 163-165 citizen 172-173 employment 180-181 peio1cow 432-433 prdtind1 472-473  enroled 575-576
weight 613-622 .4 qstnum 815-819 occurnum 820-821;


run;
proc means;
run;

data may07;
infile 'H:\research\state immigration laws\cpsfiles\may07pub.dat' lrecl=950;
input month 16-17 year 18-21 hetenure 29-30 hweight 47-56 .4
gestfips 93-94 rref 118-119 age 122-123
sex 129-130 educ 137-138 race 139-140 hispanic  157-158
marital 159-160 type 161-162 
country 163-165 citizen 172-173 employment 180-181 peio1cow 432-433 prdtind1 472-473  enroled 575-576
weight 613-622 .4 qstnum 815-819 occurnum 820-821;


run;
proc means;
run;


data jun07;
infile 'H:\research\state immigration laws\cpsfiles\jun07pub.dat' lrecl=950;
input month 16-17 year 18-21 hetenure 29-30 hweight 47-56 .4
gestfips 93-94 rref 118-119 age 122-123
sex 129-130 educ 137-138 race 139-140 hispanic  157-158
marital 159-160 type 161-162 
country 163-165 citizen 172-173 employment 180-181 peio1cow 432-433 prdtind1 472-473  enroled 575-576
weight 613-622 .4 qstnum 815-819 occurnum 820-821;


run;
proc means;
run;


data jul07;
infile 'H:\research\state immigration laws\cpsfiles\jul07pub.dat' lrecl=950;
input month 16-17 year 18-21 hetenure 29-30 hweight 47-56 .4
gestfips 93-94 rref 118-119 age 122-123
sex 129-130 educ 137-138 race 139-140 hispanic  157-158
marital 159-160 type 161-162 
country 163-165 citizen 172-173 employment 180-181 peio1cow 432-433 prdtind1 472-473  enroled 575-576
weight 613-622 .4 qstnum 815-819 occurnum 820-821;


run;
proc means;
run;


data aug07;
infile 'H:\research\state immigration laws\cpsfiles\aug07pub.dat' lrecl=950;
input month 16-17 year 18-21 hetenure 29-30 hweight 47-56 .4
gestfips 93-94 rref 118-119 age 122-123
sex 129-130 educ 137-138 race 139-140 hispanic  157-158
marital 159-160 type 161-162 
country 163-165 citizen 172-173 employment 180-181 peio1cow 432-433 prdtind1 472-473  enroled 575-576
weight 613-622 .4 qstnum 815-819 occurnum 820-821;


run;
proc means;
run;

data sep07;
infile 'H:\research\state immigration laws\cpsfiles\sep07pub.dat' lrecl=950;
input month 16-17 year 18-21 hetenure 29-30 hweight 47-56 .4
gestfips 93-94 rref 118-119 age 122-123
sex 129-130 educ 137-138 race 139-140 hispanic  157-158
marital 159-160 type 161-162 
country 163-165 citizen 172-173 employment 180-181 peio1cow 432-433 prdtind1 472-473  enroled 575-576
weight 613-622 .4 qstnum 815-819 occurnum 820-821;


run;
proc means;
run;

data oct07;
infile 'H:\research\state immigration laws\cpsfiles\oct07pub.dat' lrecl=950;
input month 16-17 year 18-21 hetenure 29-30 hweight 47-56 .4
gestfips 93-94 rref 118-119 age 122-123
sex 129-130 educ 137-138 race 139-140 hispanic  157-158
marital 159-160 type 161-162 
country 163-165 citizen 172-173 employment 180-181 peio1cow 432-433 prdtind1 472-473  enroled 575-576
weight 613-622 .4 qstnum 815-819 occurnum 820-821;


run;
proc means;
run;


data nov07;
infile 'H:\research\state immigration laws\cpsfiles\nov07pub.dat' lrecl=950;
input month 16-17 year 18-21 hetenure 29-30 hweight 47-56 .4
gestfips 93-94 rref 118-119 age 122-123
sex 129-130 educ 137-138 race 139-140 hispanic  157-158
marital 159-160 type 161-162 
country 163-165 citizen 172-173 employment 180-181 peio1cow 432-433 prdtind1 472-473  enroled 575-576
weight 613-622 .4 qstnum 815-819 occurnum 820-821;


run;
proc means;
run;

data dec07;
infile 'H:\research\state immigration laws\cpsfiles\dec07pub.dat' lrecl=950;
input month 16-17 year 18-21 hetenure 29-30 hweight 47-56 .4
gestfips 93-94 rref 118-119 age 122-123
sex 129-130 educ 137-138 race 139-140 hispanic  157-158
marital 159-160 type 161-162 
country 163-165 citizen 172-173 employment 180-181 peio1cow 432-433 prdtind1 472-473  enroled 575-576
qstnum 815-819 occurnum 820-821;


run;
proc sort;
by qstnum occurnum;
run;

proc means;
run;

data dec07revwgts;
infile 'H:\research\state immigration laws\cpsfiles\dec07revwgts.dat' lrecl=31;
input qstnum 2-6 occurnum 8-9 weight 11-20 .4;
run;
proc sort;
by qstnum occurnum;
run;

data dec07;
merge dec07(in=aa) dec07revwgts(in=bb);
by qstnum occurnum; a=aa; b=bb; ab=a*b; if ab=1;
drop a b ab;
run;



 
/****2008***/


data jan08;
infile 'H:\research\state immigration laws\cpsfiles\jan08pub.dat' lrecl=950;
input month 16-17 year 18-21 hetenure 29-30 hweight 47-56 .4
gestfips 93-94 rref 118-119 age 122-123
sex 129-130 educ 137-138 race 139-140 hispanic  157-158
marital 159-160 type 161-162 
country 163-165 citizen 172-173 employment 180-181 peio1cow 432-433 prdtind1 472-473  enroled 575-576
weight 613-622 .4 qstnum 815-819 occurnum 820-821;


run;
proc means;
run;


data feb08;
infile 'H:\research\state immigration laws\cpsfiles\feb08pub.dat' lrecl=950;
input month 16-17 year 18-21 hetenure 29-30 hweight 47-56 .4
gestfips 93-94 rref 118-119 age 122-123
sex 129-130 educ 137-138 race 139-140 hispanic  157-158
marital 159-160 type 161-162 
country 163-165 citizen 172-173 employment 180-181 peio1cow 432-433 prdtind1 472-473  enroled 575-576
weight 613-622 .4 qstnum 815-819 occurnum 820-821;


run;
proc means;
run;

data mar08;
infile 'H:\research\state immigration laws\cpsfiles\mar08pub.dat' lrecl=950;
input month 16-17 year 18-21 hetenure 29-30 hweight 47-56 .4
gestfips 93-94 rref 118-119 age 122-123
sex 129-130 educ 137-138 race 139-140 hispanic  157-158
marital 159-160 type 161-162 
country 163-165 citizen 172-173 employment 180-181 peio1cow 432-433 prdtind1 472-473  enroled 575-576
weight 613-622 .4 qstnum 815-819 occurnum 820-821;


run;
proc means;
run;

data apr08;
infile 'H:\research\state immigration laws\cpsfiles\apr08pub.dat' lrecl=950;
input month 16-17 year 18-21 hetenure 29-30 hweight 47-56 .4
gestfips 93-94 rref 118-119 age 122-123
sex 129-130 educ 137-138 race 139-140 hispanic  157-158
marital 159-160 type 161-162 
country 163-165 citizen 172-173 employment 180-181 peio1cow 432-433 prdtind1 472-473  enroled 575-576
weight 613-622 .4 qstnum 815-819 occurnum 820-821;


run;
proc means;
run;

data may08;
infile 'H:\research\state immigration laws\cpsfiles\may08pub.dat' lrecl=950;
input month 16-17 year 18-21 hetenure 29-30 hweight 47-56 .4
gestfips 93-94 rref 118-119 age 122-123
sex 129-130 educ 137-138 race 139-140 hispanic  157-158
marital 159-160 type 161-162 
country 163-165 citizen 172-173 employment 180-181 peio1cow 432-433 prdtind1 472-473  enroled 575-576
weight 613-622 .4 qstnum 815-819 occurnum 820-821;


run;
proc means;
run;


data jun08;
infile 'H:\research\state immigration laws\cpsfiles\jun08pub.dat' lrecl=950;
input month 16-17 year 18-21 hetenure 29-30 hweight 47-56 .4
gestfips 93-94 rref 118-119 age 122-123
sex 129-130 educ 137-138 race 139-140 hispanic  157-158
marital 159-160 type 161-162 
country 163-165 citizen 172-173 employment 180-181 peio1cow 432-433 prdtind1 472-473  enroled 575-576
weight 613-622 .4 qstnum 815-819 occurnum 820-821;


run;
proc means;
run;


data jul08;
infile 'H:\research\state immigration laws\cpsfiles\jul08pub.dat' lrecl=950;
input month 16-17 year 18-21 hetenure 29-30 hweight 47-56 .4
gestfips 93-94 rref 118-119 age 122-123
sex 129-130 educ 137-138 race 139-140 hispanic  157-158
marital 159-160 type 161-162 
country 163-165 citizen 172-173 employment 180-181 peio1cow 432-433 prdtind1 472-473  enroled 575-576
weight 613-622 .4 qstnum 815-819 occurnum 820-821;


run;
proc means;
run;


data aug08;
infile 'H:\research\state immigration laws\cpsfiles\aug08pub.dat' lrecl=950;
input month 16-17 year 18-21 hetenure 29-30 hweight 47-56 .4
gestfips 93-94 rref 118-119 age 122-123
sex 129-130 educ 137-138 race 139-140 hispanic  157-158
marital 159-160 type 161-162 
country 163-165 citizen 172-173 employment 180-181 peio1cow 432-433 prdtind1 472-473  enroled 575-576
weight 613-622 .4 qstnum 815-819 occurnum 820-821;


run;
proc means;
run;

data sep08;
infile 'H:\research\state immigration laws\cpsfiles\sep08pub.dat' lrecl=950;
input month 16-17 year 18-21 hetenure 29-30 hweight 47-56 .4
gestfips 93-94 rref 118-119 age 122-123
sex 129-130 educ 137-138 race 139-140 hispanic  157-158
marital 159-160 type 161-162 
country 163-165 citizen 172-173 employment 180-181 peio1cow 432-433 prdtind1 472-473  enroled 575-576
weight 613-622 .4 qstnum 815-819 occurnum 820-821;


run;
proc means;
run;

data oct08;
infile 'H:\research\state immigration laws\cpsfiles\oct08pub.dat' lrecl=950;
input month 16-17 year 18-21 hetenure 29-30 hweight 47-56 .4
gestfips 93-94 rref 118-119 age 122-123
sex 129-130 educ 137-138 race 139-140 hispanic  157-158
marital 159-160 type 161-162 
country 163-165 citizen 172-173 employment 180-181 peio1cow 432-433 prdtind1 472-473  enroled 575-576
weight 613-622 .4 qstnum 815-819 occurnum 820-821;


run;
proc means;
run;


data nov08;
infile 'H:\research\state immigration laws\cpsfiles\nov08pub.dat' lrecl=950;
input month 16-17 year 18-21 hetenure 29-30 hweight 47-56 .4
gestfips 93-94 rref 118-119 age 122-123
sex 129-130 educ 137-138 race 139-140 hispanic  157-158
marital 159-160 type 161-162 
country 163-165 citizen 172-173 employment 180-181 peio1cow 432-433 prdtind1 472-473  enroled 575-576
weight 613-622 .4 qstnum 815-819 occurnum 820-821;


run;
proc means;
run;

data dec08;
infile 'H:\research\state immigration laws\cpsfiles\dec08pub.dat' lrecl=950;
input month 16-17 year 18-21 hetenure 29-30 hweight 47-56 .4
gestfips 93-94 rref 118-119 age 122-123
sex 129-130 educ 137-138 race 139-140 hispanic  157-158
marital 159-160 type 161-162 
country 163-165 citizen 172-173 employment 180-181 peio1cow 432-433 prdtind1 472-473  enroled 575-576
weight 613-622 .4 qstnum 815-819 occurnum 820-821;


run;
proc means;
run;

data jan09;
infile 'H:\research\state immigration laws\cpsfiles\jan09pub.dat' lrecl=950;
input month 16-17 year 18-21 hetenure 29-30 hweight 47-56 .4
gestfips 93-94 rref 118-119 age 122-123
sex 129-130 educ 137-138 race 139-140 hispanic  157-158
marital 159-160 type 161-162 
country 163-165 citizen 172-173 employment 180-181 peio1cow 432-433 prdtind1 472-473  enroled 575-576
weight 613-622 .4 qstnum 815-819 occurnum 820-821;


run;
proc means;
run;


data feb09;
infile 'H:\research\state immigration laws\cpsfiles\feb09pub.dat' lrecl=950;
input month 16-17 year 18-21 hetenure 29-30 hweight 47-56 .4
gestfips 93-94 rref 118-119 age 122-123
sex 129-130 educ 137-138 race 139-140 hispanic  157-158
marital 159-160 type 161-162 
country 163-165 citizen 172-173 employment 180-181 peio1cow 432-433 prdtind1 472-473  enroled 575-576
weight 613-622 .4 qstnum 815-819 occurnum 820-821;


run;
proc means;
run;

data mar09;
infile 'H:\research\state immigration laws\cpsfiles\mar09pub.dat' lrecl=950;
input month 16-17 year 18-21 hetenure 29-30 hweight 47-56 .4
gestfips 93-94 rref 118-119 age 122-123
sex 129-130 educ 137-138 race 139-140 hispanic  157-158
marital 159-160 type 161-162 
country 163-165 citizen 172-173 employment 180-181 peio1cow 432-433 prdtind1 472-473  enroled 575-576
weight 613-622 .4 qstnum 815-819 occurnum 820-821;


run;
proc means;
run;

data apr09;
infile 'H:\research\state immigration laws\cpsfiles\apr09pub.dat' lrecl=950;
input month 16-17 year 18-21 hetenure 29-30 hweight 47-56 .4
gestfips 93-94 rref 118-119 age 122-123
sex 129-130 educ 137-138 race 139-140 hispanic  157-158
marital 159-160 type 161-162 
country 163-165 citizen 172-173 employment 180-181 peio1cow 432-433 prdtind1 472-473  enroled 575-576
weight 613-622 .4 qstnum 815-819 occurnum 820-821;


run;
proc means;
run;

data may09;
infile 'H:\research\state immigration laws\cpsfiles\may09pub.dat' lrecl=950;
input month 16-17 year 18-21 hetenure 29-30 hweight 47-56 .4
gestfips 93-94 rref 118-119 age 122-123
sex 129-130 educ 137-138 race 139-140 hispanic  157-158
marital 159-160 type 161-162 
country 163-165 citizen 172-173 employment 180-181 peio1cow 432-433 prdtind1 472-473  enroled 575-576
weight 613-622 .4 qstnum 815-819 occurnum 820-821;


run;
proc means;
run;


data jun09;
infile 'H:\research\state immigration laws\cpsfiles\jun09pub.dat' lrecl=950;
input month 16-17 year 18-21 hetenure 29-30 hweight 47-56 .4
gestfips 93-94 rref 118-119 age 122-123
sex 129-130 educ 137-138 race 139-140 hispanic  157-158
marital 159-160 type 161-162 
country 163-165 citizen 172-173 employment 180-181 peio1cow 432-433 prdtind1 472-473  enroled 575-576
weight 613-622 .4 qstnum 815-819 occurnum 820-821;


run;
proc means;
run;


data jul09;
infile 'H:\research\state immigration laws\cpsfiles\jul09pub.dat' lrecl=950;
input month 16-17 year 18-21 hetenure 29-30 hweight 47-56 .4
gestfips 93-94 rref 118-119 age 122-123
sex 129-130 educ 137-138 race 139-140 hispanic  157-158
marital 159-160 type 161-162 
country 163-165 citizen 172-173 employment 180-181 peio1cow 432-433 prdtind1 472-473  enroled 575-576
weight 613-622 .4 qstnum 815-819 occurnum 820-821;


run;
proc means;
run;


data aug09;
infile 'H:\research\state immigration laws\cpsfiles\aug09pub.dat' lrecl=950;
input month 16-17 year 18-21 hetenure 29-30 hweight 47-56 .4
gestfips 93-94 rref 118-119 age 122-123
sex 129-130 educ 137-138 race 139-140 hispanic  157-158
marital 159-160 type 161-162 
country 163-165 citizen 172-173 employment 180-181 peio1cow 432-433 prdtind1 472-473  enroled 575-576
weight 613-622 .4 qstnum 815-819 occurnum 820-821;


run;
proc means;
run;

data sep09;
infile 'H:\research\state immigration laws\cpsfiles\sep09pub.dat' lrecl=950;
input month 16-17 year 18-21 hetenure 29-30 hweight 47-56 .4
gestfips 93-94 rref 118-119 age 122-123
sex 129-130 educ 137-138 race 139-140 hispanic  157-158
marital 159-160 type 161-162 
country 163-165 citizen 172-173 employment 180-181 peio1cow 432-433 prdtind1 472-473  enroled 575-576
weight 613-622 .4 qstnum 815-819 occurnum 820-821;


run;
proc means;
run;

data oct09;
infile 'H:\research\state immigration laws\cpsfiles\oct09pub.dat' lrecl=950;
input month 16-17 year 18-21 hetenure 29-30 hweight 47-56 .4
gestfips 93-94 rref 118-119 age 122-123
sex 129-130 educ 137-138 race 139-140 hispanic  157-158
marital 159-160 type 161-162 
country 163-165 citizen 172-173 employment 180-181 peio1cow 432-433 prdtind1 472-473  enroled 575-576
weight 613-622 .4 qstnum 815-819 occurnum 820-821;


run;
proc means;
run;


data nov09;
infile 'H:\research\state immigration laws\cpsfiles\nov09pub.dat' lrecl=950;
input month 16-17 year 18-21 hetenure 29-30 hweight 47-56 .4
gestfips 93-94 rref 118-119 age 122-123
sex 129-130 educ 137-138 race 139-140 hispanic  157-158
marital 159-160 type 161-162 
country 163-165 citizen 172-173 employment 180-181 peio1cow 432-433 prdtind1 472-473  enroled 575-576
weight 613-622 .4 qstnum 815-819 occurnum 820-821;


run;
proc means;
run;

data dec09;
infile 'H:\research\state immigration laws\cpsfiles\dec09pub.dat' lrecl=950;
input month 16-17 year 18-21 hetenure 29-30 hweight 47-56 .4
gestfips 93-94 rref 118-119 age 122-123
sex 129-130 educ 137-138 race 139-140 hispanic  157-158
marital 159-160 type 161-162 
country 163-165 citizen 172-173 employment 180-181 peio1cow 432-433 prdtind1 472-473  enroled 575-576
weight 613-622 .4 qstnum 815-819 occurnum 820-821;


run;
 
proc means;
run;

data everify.combined0309 (compress=yes);
set 
jan03 feb03 mar03 apr03 may03 jun03 jul03 aug03 sep03 oct03 nov03 dec03
jan04 feb04 mar04 apr04 may04 jun04 jul04 aug04 sep04 oct04 nov04 dec04
jan05 feb05 mar05 apr05 may05 jun05 jul05 aug05 sep05 oct05 nov05 dec05
jan06 feb06 mar06 apr06 may06 jun06 jul06 aug06 sep06 oct06 nov06 dec06
jan07 feb07 mar07 apr07 may07 jun07 jul07 aug07 sep07 oct07 nov07 dec07
jan08 feb08 mar08 apr08 may08 jun08 jul08 aug08 sep08 oct08 nov08 dec08
jan09 feb09 mar09 apr09 may09 jun09 jul09 aug09 sep09 oct09 nov09 dec09;
if weight>0;
run;
proc means;
run;
 
